trajectory_analysis
2023-12-28
Trajectory Analysis
Explanation about coordinate system:
The coordinates of player are extracted from the unity component
“Transform” 
The coordinate origin and coordinate system are shown in the
figure:
Recording frequency: Every 0.5 second.
Data preprocess:
1. copy the raw data to a new “workfiles” folder
library(tidyverse)## ── Attaching core tidyverse packages ──────────────────────── tidyverse 2.0.0 ──
## ✔ dplyr 1.1.2 ✔ readr 2.1.4
## ✔ forcats 1.0.0 ✔ stringr 1.5.0
## ✔ ggplot2 3.4.2 ✔ tibble 3.2.1
## ✔ lubridate 1.9.2 ✔ tidyr 1.3.0
## ✔ purrr 1.0.1
## ── Conflicts ────────────────────────────────────────── tidyverse_conflicts() ──
## ✖ dplyr::filter() masks stats::filter()
## ✖ dplyr::lag() masks stats::lag()
## ℹ Use the conflicted package (<http://conflicted.r-lib.org/>) to force all conflicts to become errorslibrary(fs)
# Define the folder paths
log_folder <- "log_files"
working_folder <- "workfiles"
# Create the working folder if it doesn't exist
dir_create(working_folder)
# Copy files from log_files to the working folder
files_to_copy <- dir_ls(log_folder)
for (file in files_to_copy) {
file_copy(file, file.path(working_folder, basename(file)))
}2. Clean_up the data
# for participant 17 s3t3, there were 3 taskaccpeted because the participant set the wrong destination 2 times, should delete two meaningfulless taskaccepted(Found that also duplicated setNavitaion, but it will not cause influence to the results)
data <- read.csv("workfiles/participant_17_scenario_3_s_at_2023.09.28_11.33.58.csv", sep = ";")
taskAccept_indices <- which(data$taskState == "taskAccepted")
indices_to_replace <- taskAccept_indices[4:5]
# Replace "taskAccept" with empty string ("")
data$taskState[indices_to_replace] <- ""
# Write the modified data back to the CSV file
write.table(data, file = "workfiles/participant_17_scenario_3_s_at_2023.09.28_11.33.58.csv", sep = ";", row.names = FALSE, col.names = TRUE, quote = FALSE)
##### same as 27 s1t3
data <- read.csv("workfiles/participant_27_scenario_1_w_at_2023.10.04_16.40.08.csv", sep = ";")
taskAccept_indices <- which(data$taskState == "taskAccepted")
indices_to_replace <- taskAccept_indices[4]
data$taskState[indices_to_replace] <- ""
write.table(data, file = "workfiles/participant_27_scenario_1_w_at_2023.10.04_16.40.08.csv", sep = ";", row.names = FALSE, col.names = TRUE, quote = FALSE)
##### same as 27 s3t3
data <- read.csv("workfiles/participant_27_scenario_3_e_at_2023.10.04_16.15.54.csv", sep = ";")
taskAccept_indices <- which(data$taskState == "taskAccepted")
indices_to_replace <- taskAccept_indices[4]
data$taskState[indices_to_replace] <- ""
write.table(data, file = "workfiles/participant_27_scenario_3_e_at_2023.10.04_16.15.54.csv", sep = ";", row.names = FALSE, col.names = TRUE, quote = FALSE)
##### same as 38 s3t1
data <- read.csv("workfiles/participant_38_scenario_3_w_at_2023.10.11_16.40.07.csv", sep = ";")
taskAccept_indices <- which(data$taskState == "taskAccepted")
indices_to_replace <- taskAccept_indices[2]
data$taskState[indices_to_replace] <- ""
write.table(data, file = "workfiles/participant_38_scenario_3_w_at_2023.10.11_16.40.07.csv", sep = ";", row.names = FALSE, col.names = TRUE, quote = FALSE)
##### same as 44 s1t4
data <- read.csv("workfiles/participant_44_scenario_1_s_at_2023.10.13_16.29.40.csv", sep = ";")
taskAccept_indices <- which(data$taskState == "taskAccepted")
indices_to_replace <- taskAccept_indices[5]
data$taskState[indices_to_replace] <- ""
write.table(data, file = "workfiles/participant_44_scenario_1_s_at_2023.10.13_16.29.40.csv", sep = ";", row.names = FALSE, col.names = TRUE, quote = FALSE)
##### same as 45 s3t3
data <- read.csv("workfiles/participant_45_scenario_3_s_at_2023.10.17_11.09.23.csv", sep = ";")
taskAccept_indices <- which(data$taskState == "taskAccepted")
indices_to_replace <- taskAccept_indices[4]
data$taskState[indices_to_replace] <- ""
write.table(data, file = "workfiles/participant_45_scenario_3_s_at_2023.10.17_11.09.23.csv", sep = ";", row.names = FALSE, col.names = TRUE, quote = FALSE)
##### same as 62 s2t4
data <- read.csv("workfiles/participant_62_scenario_2_n_at_2023.10.27_16.31.15.csv", sep = ";")
taskAccept_indices <- which(data$taskState == "taskAccepted")
indices_to_replace <- taskAccept_indices[5]
data$taskState[indices_to_replace] <- ""
write.table(data, file = "workfiles/participant_62_scenario_2_n_at_2023.10.27_16.31.15.csv", sep = ";", row.names = FALSE, col.names = TRUE, quote = FALSE)
##### 32 s1t2 there were 2 taskaccpeted with no reason
data <- read.csv("workfiles/participant_32_scenario_1_e_at_2023.10.06_11.00.18.csv", sep = ";")
taskAccept_indices <- which(data$taskState == "taskAccepted")
indices_to_replace <- taskAccept_indices[3]
data$taskState[indices_to_replace] <- ""
write.table(data, file = "workfiles/participant_32_scenario_1_e_at_2023.10.06_11.00.18.csv", sep = ";", row.names = FALSE, col.names = TRUE, quote = FALSE)
##### 59 s3t3 there were no tcheckedin because used F9, replace F9 with CheckedIn_migros
data <- read.csv("workfiles/participant_59_scenario_3_e_at_2023.10.26_15.53.32.csv", sep = ";")
taskAccept_indices <- which(data$taskState == "DEBUG_IGNORE_ME: GameStart::scenario_selected.gameTasks.Count = 1")
indices_to_replace <- taskAccept_indices[1]
data$taskState[indices_to_replace] <- "checkedIn:migros"
write.table(data, file = "workfiles/participant_59_scenario_3_e_at_2023.10.26_15.53.32.csv", sep = ";", row.names = FALSE, col.names = TRUE, quote = FALSE)Data process:
In this part, I processed the raw data and got the new variables about the trajectory analysis.
They are about length, time, speed, stops, stop time. (Because each participant had 4 tasks each scenario, I calculate length, time, stops, stop time of separate task also the sum of them, taking into account that this makes more sense as well as to prepare for future analysis.) I will give explanations about them respectively.
Workflow:
- Initialize a new empty data frame to store the results and store it as a new csv file for the further analysis.
- Use a loop to go through each CSV file.
- Initialize new vectors to store length, time, stops, stop time, (speed can be calculated with length and time easily).
- Use task_accepted_indices and end_index to separate each task and get a subset for each task.
- Calculate length.
- Calculate time.
- Calculate walking stops.
- Calculate walking stop time.
- Extract the participant information from file name.
- Get the result.
- Store as new file.
Calculate length:
Calculate Euclidean distances between consecutive points in the trajectory then sum them.
Calculate time:
Extract the start time and end time for each task which is the DateTime from the first point and last point of the subset. Get time duration for each task then sum them.
Calculate walking stops:
If the coordinates are the same among consecutive points, I regard these consecutive points as a walking stop.
Calculate walking stop time:
Use stop_indices and start_indices to get the start point and end point of each walking stop. Then calculate the time of each walking stops then sum them.
## Warning: NAs introduced by coercion
## Warning: NAs introduced by coercion## participantno scenario startpoint lg_1 lg_2 lg_3 lg_4
## 1 10 1 n 298.47098 175.17558 58.37155 83.92620
## 2 10 2 e 257.11124 152.57155 156.73153 320.28728
## 3 10 3 s 159.46996 309.72227 86.23219 442.84272
## 4 10 4 w 194.53284 462.81476 265.83012 256.44023
## 5 12 1 s 76.07643 201.39341 185.10973 240.73379
## 6 12 2 w 307.59492 247.82291 45.98631 344.73930
## 7 12 3 n 231.87522 280.27264 201.28460 184.82423
## 8 12 4 e 149.10454 125.24246 216.93737 177.97314
## 9 13 1 n 63.26669 230.39831 115.23920 183.16612
## 10 13 2 e 238.11275 76.50361 139.69174 126.00679
## 11 13 3 s 167.88456 102.45495 60.23065 156.86747
## 12 13 4 w 189.97557 315.14463 387.92139 178.71396
## 13 15 1 w 115.46456 122.50526 237.34840 148.59514
## 14 15 2 s 363.04987 168.80174 115.10352 308.37765
## 15 15 3 n 238.12308 310.50991 83.44824 369.42549
## 16 15 4 e 315.51542 757.23610 258.19136 264.56161
## 17 16 1 e 209.60176 216.53928 117.92258 21.88370
## 18 16 2 w 281.37010 193.81080 153.24039 264.45003
## 19 16 3 s 158.44819 100.60791 63.76827 187.60799
## 20 16 4 n 73.24566 326.30089 227.69069 172.05200
## 21 17 1 w 139.53233 369.66094 135.01212 124.13716
## 22 17 2 n 197.82430 95.80984 251.53248 182.66430
## 23 17 3 s 147.56208 113.55174 393.45519 334.41100
## 24 17 4 e 197.11181 92.75701 223.50622 336.58300
## 25 18 1 s 77.89439 167.14366 158.72800 242.35834
## 26 18 2 w 556.61989 80.76724 148.10762 222.17165
## 27 18 3 n 194.50438 206.23927 199.39442 54.05271
## 28 18 4 e 124.95173 135.93582 82.07979 137.87584
## 29 19 1 e 208.15737 307.21986 50.97791 125.98900
## 30 19 2 s 228.49116 217.02205 78.32842 40.89508
## 31 19 3 w 212.44282 69.41591 193.26054 92.56225
## 32 19 4 n 64.13484 207.62425 113.12503 210.84765
## 33 20 1 n 64.02803 247.39121 127.21542 210.37626
## 34 20 2 e 228.20905 140.06200 150.02795 160.95226
## 35 20 3 s 150.92116 117.35433 172.99514 31.43784
## 36 20 4 w 185.68552 255.48843 256.62440 149.34149
## 37 21 1 s 78.29299 181.84186 178.37927 265.22785
## 38 21 2 w 339.29899 495.22445 371.54334 208.98974
## 39 21 3 e 254.81495 243.56335 370.11748 79.03360
## 40 21 4 n 61.91210 216.79761 112.79489 129.56681
## 41 22 1 e 227.90491 377.10719 98.05496 127.23017
## 42 22 2 s 380.37193 217.07362 76.48392 49.90422
## 43 22 3 w 209.72651 69.23054 226.62524 231.69424
## 44 22 4 n 76.84593 230.93877 126.71884 137.26766
## 45 23 1 n 67.98972 218.45354 145.93111 148.64597
## 46 23 2 e 431.32283 197.54176 82.32274 167.10545
## 47 23 3 s 590.49841 83.82237 93.08029 131.92467
## 48 23 4 w 230.47803 513.65856 196.86128 192.06669
## 49 24 1 w 116.50019 327.53392 134.67796 172.24074
## 50 24 2 n 183.74019 65.07177 477.41754 56.23381
## 51 24 3 e 191.22452 181.36096 75.66692 124.03158
## 52 24 4 s 86.25271 255.73809 289.05437 157.28041
## 53 25 1 e 206.46553 212.24889 77.81900 47.12534
## 54 25 2 s 329.22042 159.84143 81.66481 41.66509
## 55 25 3 n 210.64759 261.70380 155.63418 127.09081
## 56 25 4 w 214.06584 471.19513 199.13499 164.86278
## 57 26 1 n 73.42316 252.10793 118.50398 242.54518
## 58 26 2 e 242.10390 126.60694 209.67770 272.26841
## 59 26 3 s 147.23295 359.65942 99.85757 309.14154
## 60 26 4 w 216.30487 309.29165 254.88646 217.29945
## 61 27 1 w 120.44800 169.32930 240.34184 147.03387
## 62 27 2 n 265.18308 64.76172 169.75352 179.07174
## 63 27 3 e 193.61444 152.00927 64.75666 63.43273
## 64 27 4 s 73.54576 233.90441 79.92338 126.20183
## 65 28 1 s 70.56087 191.87028 42.66132 268.77021
## 66 28 2 w 244.01623 175.05891 219.96165 200.71774
## 67 28 3 n 345.31930 59.49038 73.50245 117.15807
## 68 28 4 e 128.00997 132.52496 88.81364 139.07021
## 69 29 1 n 64.21752 236.40773 203.54952 289.97472
## 70 29 2 e 235.30613 393.61351 222.34489 121.55924
## 71 29 3 s 153.53182 98.66170 63.72583 162.46148
## 72 29 4 w 188.43561 352.46969 163.32489 148.71062
## 73 30 1 s 78.54235 136.61926 148.92535 214.20409
## 74 30 2 n 200.73725 88.00504 174.70346 162.93050
## 75 30 3 e 220.67408 208.13929 60.12513 75.14672
## 76 30 4 w 194.02309 296.84429 236.04237 188.92158
## 77 31 1 w 118.63243 137.68416 305.30260 141.93327
## 78 31 2 s 238.24804 210.99789 90.79606 58.56486
## 79 31 3 n 166.25847 264.57295 480.46630 NA
## 80 31 4 e 404.13499 162.37088 273.62953 159.70796
## 81 32 1 e 206.20529 235.48998 94.75378 25.33807
## 82 32 2 w 269.38455 244.61630 52.92138 384.56601
## 83 32 3 s 136.26284 106.81811 274.49775 169.75742
## 84 32 4 n 76.72668 198.56399 124.47062 266.87459
## 85 33 1 w 116.67704 325.66701 235.41536 159.36117
## 86 33 2 n 190.01041 192.19655 336.85368 151.58243
## 87 33 3 s 152.35329 117.36490 167.17289 149.65185
## 88 33 4 e 132.67438 125.93037 222.21303 37.06965
## 89 34 1 s 75.54377 249.86125 27.42493 231.56542
## 90 34 2 w 280.37464 182.10459 280.82215 200.23473
## 91 34 3 n 237.44848 227.73727 194.29731 45.68008
## 92 34 4 e 159.54237 267.68755 75.13360 34.68797
## 93 35 1 e 203.11907 218.78365 80.79860 25.94178
## 94 35 2 s 283.03697 147.96694 86.27829 43.39024
## 95 35 3 w 192.26261 58.74734 220.43028 96.27228
## 96 35 4 n 60.21859 181.43680 158.55001 238.81930
## 97 36 1 n 66.74408 245.19510 113.02853 187.21515
## 98 36 2 e 237.31852 79.28909 142.77244 122.19949
## 99 36 3 s 145.16294 100.48300 76.05260 167.36007
## 100 36 4 w 210.68525 274.49378 209.73050 170.24279
## 101 37 1 s 81.83867 255.71673 532.06562 410.35139
## 102 37 2 w 273.01051 464.92502 138.41897 293.60812
## 103 37 3 e 470.16767 144.48273 195.17222 56.00969
## 104 37 4 n 66.84010 228.42909 312.43499 126.35075
## 105 38 1 e 256.91610 309.34740 130.79881 330.45970
## 106 38 2 s 435.32687 377.06935 121.22490 35.57814
## 107 38 3 w 253.74152 97.51126 234.50593 587.40890
## 108 38 4 n 128.93012 86.94002 460.00770 333.21616
## 109 39 1 n 64.89651 223.48438 126.51762 182.09172
## 110 39 2 e 236.46313 83.73070 153.48908 243.33357
## 111 39 3 s 160.06260 164.67762 173.26289 180.28586
## 112 39 4 w 162.37959 275.55525 367.64455 171.54160
## 113 40 1 w 115.79542 130.82765 273.13464 197.14266
## 114 40 2 n 230.89427 122.84301 225.44384 145.91445
## 115 40 3 e 174.27522 162.75560 90.97534 104.33464
## 116 40 4 s 84.02168 264.02457 39.42696 53.22722
## 117 41 1 e 224.46283 213.75354 82.95143 249.67433
## 118 41 2 s 299.17806 139.05895 66.32200 44.25978
## 119 41 3 n 179.04989 194.20779 191.23386 51.58805
## 120 41 4 w 189.02241 344.98434 258.31357 157.85818
## 121 42 1 n 69.12124 166.81140 118.88010 174.62763
## 122 42 2 e 239.44076 79.75392 141.71202 116.60056
## 123 42 3 s 141.02346 113.62358 67.52359 163.19373
## 124 42 4 w 171.58935 284.08136 196.58319 161.83497
## 125 43 1 w 122.85028 612.45375 36.22024 102.19166
## 126 43 2 n 215.09272 90.47805 184.97721 186.80991
## 127 43 3 e 212.07038 220.65672 60.38779 107.57681
## 128 43 4 s 247.33354 169.24279 35.89752 97.94771
## 129 44 1 s 76.90581 252.92069 41.61363 56.55611
## 130 44 2 w 246.56357 168.76664 123.86773 157.79500
## 131 44 3 n 145.75989 183.11882 205.48159 170.72938
## 132 44 4 e 143.31981 131.25270 80.56447 137.21626
## 133 45 1 n 66.68224 167.74471 214.57242 258.81570
## 134 45 2 e 539.93197 95.32083 80.62449 129.75022
## 135 45 3 s 153.79596 123.34281 548.83181 93.42465
## 136 45 4 w 165.03549 327.02437 172.59262 165.44306
## 137 46 1 s 76.52923 189.12248 180.87506 79.41797
## 138 46 2 n 192.57286 74.01086 203.26862 153.32318
## 139 46 3 e 195.99592 161.90563 58.30095 113.31009
## 140 46 4 w 248.64714 471.15795 206.78805 169.18290
## 141 47 1 w 115.21466 133.42838 260.16841 150.89280
## 142 47 2 s 264.86109 185.34060 68.10385 98.65126
## 143 47 3 n 147.22773 209.12067 202.45988 45.04138
## 144 47 4 e 129.19844 130.46217 94.10359 137.14868
## 145 48 1 e 213.37181 312.15384 88.66862 158.86657
## 146 48 2 w 259.38861 525.70449 167.15763 172.96231
## 147 48 3 s 156.22897 112.96454 68.42881 278.24345
## 148 48 4 n 63.16479 370.86903 43.42376 176.48881
## 149 49 1 w 143.07719 126.63923 249.03070 149.07209
## 150 49 2 n 196.93371 75.42020 252.13102 170.59008
## 151 49 3 s 146.20556 276.22420 79.01135 191.68894
## 152 49 4 e 186.93466 132.48491 101.66143 230.24912
## 153 50 1 s 80.20656 192.83048 190.72920 235.64664
## 154 50 2 w 303.62638 213.29270 164.09230 168.79479
## 155 50 3 n 145.24671 185.66731 206.10043 52.17176
## 156 50 4 e 126.49050 126.66694 95.28227 139.30597
## 157 51 1 e 199.22777 239.12033 85.96731 248.88183
## 158 51 2 s 365.95844 388.73656 214.84913 321.66661
## 159 51 3 w 485.30300 250.58136 71.32874 366.02026
## 160 51 4 n 119.79391 88.48474 323.03401 29.49660
## 161 52 1 n 67.37663 219.27404 335.74371 153.77258
## 162 52 2 e 235.41370 86.02805 216.15605 306.10843
## 163 52 3 s 156.70188 125.24755 175.30621 56.74642
## 164 52 4 w 180.89108 325.85562 201.68089 175.47222
## 165 53 1 s 74.73453 362.42102 82.46815 120.32956
## 166 53 2 w 249.97375 176.33691 115.75398 178.91531
## 167 53 3 e 187.93114 162.08919 58.97559 74.95702
## 168 53 4 n 58.86107 180.25116 176.56948 119.98335
## 169 54 1 e 226.70691 224.06288 82.11550 24.25442
## 170 54 2 s 235.97411 192.06517 121.72346 80.07491
## 171 54 3 w 220.26139 64.85368 205.51428 160.21145
## 172 54 4 n 72.53474 200.36362 115.46594 236.19910
## 173 55 1 n 65.13617 241.55444 111.13023 150.28805
## 174 55 2 e 231.57170 75.06598 216.17786 294.77983
## 175 55 3 s 148.55986 98.86909 100.76438 153.68371
## 176 55 4 w 239.50256 480.85638 209.80646 175.16370
## 177 56 1 w 116.89652 142.22204 245.17500 118.76445
## 178 56 2 n 183.11046 78.91543 166.48627 163.31193
## 179 56 3 e 191.66127 184.54836 58.66655 71.32856
## 180 56 4 s 86.82509 221.87088 88.90660 129.75895
## 181 57 1 e 210.69491 313.10832 100.33795 165.71308
## 182 57 2 s 343.54453 152.04982 84.45000 49.54349
## 183 57 3 n 227.23629 173.31443 212.84979 51.25535
## 184 57 4 w 222.11042 337.29756 501.63170 178.83668
## 185 58 1 n 66.52579 234.94929 142.68256 148.67368
## 186 58 2 e 248.83020 103.04849 150.59532 118.46982
## 187 58 3 s 143.84925 119.31808 188.28651 110.47474
## 188 58 4 w 197.85632 282.44860 194.86852 166.43024
## 189 59 1 w 140.01218 168.87730 264.18543 164.35329
## 190 59 2 n 222.87786 77.89876 174.58096 182.42599
## 191 59 3 e 516.25113 144.04669 215.41169 128.78833
## 192 59 4 s 116.15601 223.92579 149.86224 158.41873
## 193 60 1 s 65.86185 379.70287 196.03874 129.98423
## 194 60 2 w 647.96926 122.32216 151.10322 24.89610
## 195 60 3 n 147.20454 158.87364 194.64076 44.89424
## 196 60 4 e 607.51721 158.80192 579.61633 128.85876
## 197 61 1 n 63.78947 483.07828 83.55963 135.39455
## 198 61 2 e 231.13175 81.53467 378.21138 122.46216
## 199 61 3 s 151.03606 101.07366 69.42496 319.79049
## 200 61 4 w 187.58006 291.32391 194.68772 132.53045
## 201 62 1 s 77.54181 259.31083 30.02188 244.05993
## 202 62 2 n 206.60223 94.45475 250.14339 188.75910
## 203 62 3 e 657.92769 67.66209 198.70852 126.37671
## 204 62 4 w 211.17934 507.13011 248.69095 160.94433
## 205 63 1 w 132.81463 144.69999 239.90001 164.67435
## 206 63 2 s 315.55758 156.22982 91.67977 60.63353
## 207 63 3 n 148.33289 212.15045 204.92719 48.36741
## 208 63 4 e 136.42273 124.22491 211.25485 164.57882
## 209 8 1 w 171.71018 337.47535 296.74136 189.42293
## 210 8 2 n 560.85912 115.33636 200.43569 77.46560
## 211 8 3 e 234.86104 172.28904 72.05856 102.32297
## 212 8 4 s 71.37930 337.01199 311.71227 248.08571
## 213 9 1 e 213.70050 253.27797 83.83465 26.37732
## 214 9 2 s 281.62375 160.49764 81.59201 43.50733
## 215 9 3 n 142.16410 159.83942 212.18494 56.31270
## 216 9 4 w 237.46469 496.23729 209.53552 175.53312
## total_length duration_1 duration_2 duration_3 duration_4 total_duration
## 1 615.9443 145 68 24 40 277
## 2 886.7016 114 69 61 155 399
## 3 998.2671 79 205 62 255 601
## 4 1179.6180 87 222 119 105 533
## 5 703.3134 57 109 111 106 383
## 6 946.1434 136 98 30 163 427
## 7 898.2567 148 202 122 142 614
## 8 669.2575 103 106 102 123 434
## 9 592.0703 34 103 50 67 254
## 10 580.3149 90 45 58 54 247
## 11 487.4376 89 55 38 81 263
## 12 1071.7556 75 136 190 76 477
## 13 623.9133 93 63 104 56 316
## 14 955.3328 147 68 50 120 385
## 15 1001.5067 166 201 68 178 613
## 16 1595.5045 170 386 198 165 919
## 17 565.9473 121 113 63 37 334
## 18 892.8713 135 84 123 154 496
## 19 510.4324 88 90 45 126 349
## 20 799.2892 86 278 203 144 711
## 21 768.3426 75 152 104 81 412
## 22 727.8309 121 74 127 105 427
## 23 988.9800 74 82 322 153 631
## 24 849.9580 83 48 99 175 405
## 25 646.1244 42 75 89 103 309
## 26 1007.6664 232 47 63 115 457
## 27 654.1908 136 130 105 30 401
## 28 480.8432 63 61 46 73 243
## 29 692.3441 82 123 25 75 305
## 30 564.7367 90 96 29 20 235
## 31 567.6815 119 67 129 51 366
## 32 595.7318 37 96 56 118 307
## 33 649.0109 56 128 60 104 348
## 34 679.2513 89 59 63 69 280
## 35 472.7085 64 56 71 20 211
## 36 847.1398 79 126 120 80 405
## 37 703.7420 58 105 79 120 362
## 38 1415.0565 134 178 146 87 545
## 39 947.5294 126 119 169 52 466
## 40 521.0714 44 103 62 53 262
## 41 830.2972 146 192 63 89 490
## 42 723.8337 159 101 47 46 353
## 43 737.2765 132 61 152 147 492
## 44 571.7712 72 109 77 74 332
## 45 581.0203 42 88 56 57 243
## 46 878.2928 176 88 47 73 384
## 47 899.3257 258 68 66 70 462
## 48 1133.0646 129 232 97 120 578
## 49 750.9528 69 143 69 95 376
## 50 782.4633 85 46 207 35 373
## 51 572.2840 101 99 57 81 338
## 52 788.3256 72 137 175 89 473
## 53 543.6588 96 103 42 35 276
## 54 612.3917 138 67 39 26 270
## 55 755.0764 111 145 77 55 388
## 56 1049.2588 118 203 83 65 469
## 57 686.5802 46 110 74 128 358
## 58 850.6570 107 60 109 137 413
## 59 915.8915 79 224 64 160 527
## 60 997.7824 116 112 138 112 478
## 61 677.1530 50 87 123 54 314
## 62 678.7701 106 30 66 67 269
## 63 473.8131 88 79 52 36 255
## 64 513.5754 31 110 43 52 236
## 65 573.8627 35 73 30 107 245
## 66 839.7545 97 65 94 85 341
## 67 595.4702 167 28 38 67 300
## 68 488.4188 68 62 69 70 269
## 69 794.1495 49 149 91 175 464
## 70 972.8238 123 170 105 71 469
## 71 478.3808 92 87 48 87 314
## 72 852.9408 104 155 93 59 411
## 73 578.2910 61 72 79 106 318
## 74 626.3763 121 72 136 114 443
## 75 564.0852 143 169 108 55 475
## 76 915.8313 102 174 136 99 511
## 77 703.5525 80 86 169 102 437
## 78 598.6069 115 99 57 30 301
## 79 911.2977 143 176 251 NA 570
## 80 999.8434 275 78 159 69 581
## 81 561.7871 103 161 58 15 337
## 82 951.4882 115 101 28 188 432
## 83 687.3361 66 61 132 86 345
## 84 666.6359 51 101 118 150 420
## 85 837.1206 70 148 127 102 447
## 86 870.6431 110 109 153 86 458
## 87 586.5429 113 69 98 103 383
## 88 517.8874 87 63 114 26 290
## 89 584.3954 69 161 31 153 414
## 90 943.5361 165 105 130 96 496
## 91 705.1631 226 163 107 31 527
## 92 537.0515 109 170 56 29 364
## 93 528.6431 81 97 36 18 232
## 94 560.6724 116 64 33 17 230
## 95 567.7125 81 43 128 60 312
## 96 639.0247 41 77 97 227 442
## 97 612.1829 50 135 59 102 346
## 98 581.5795 111 54 69 61 295
## 99 489.0586 90 67 58 94 309
## 100 865.1523 103 144 111 89 447
## 101 1279.9724 57 134 318 222 731
## 102 1169.9626 132 216 69 136 553
## 103 865.8323 277 106 488 41 912
## 104 734.0549 65 166 169 64 464
## 105 1027.5220 143 149 62 140 494
## 106 969.1993 219 186 84 45 534
## 107 1173.1676 193 95 164 376 828
## 108 1009.0940 96 90 339 190 715
## 109 596.9902 32 113 64 82 291
## 110 717.0165 109 46 66 138 359
## 111 678.2890 108 109 83 109 409
## 112 977.1210 90 148 203 76 517
## 113 716.9004 52 53 155 87 347
## 114 725.0956 99 67 134 75 375
## 115 532.3408 98 88 60 71 317
## 116 440.7004 73 154 29 46 302
## 117 770.8421 120 106 81 127 434
## 118 548.8188 151 103 48 62 364
## 119 616.0796 117 131 119 59 426
## 120 950.1785 115 187 133 78 513
## 121 529.4404 38 73 60 68 239
## 122 577.5073 97 48 69 60 274
## 123 485.3644 60 69 36 81 246
## 124 814.0889 90 123 110 66 389
## 125 873.7159 58 265 26 82 431
## 126 677.3579 103 50 82 96 331
## 127 600.6917 117 201 57 76 451
## 128 550.4216 136 88 35 60 319
## 129 427.9962 78 131 36 63 308
## 130 696.9929 108 83 72 96 359
## 131 705.0897 98 112 107 82 399
## 132 492.3532 111 89 68 108 376
## 133 707.8151 43 71 90 110 314
## 134 845.6275 217 43 32 49 341
## 135 919.3952 69 65 232 48 414
## 136 830.0955 72 134 78 65 349
## 137 525.9447 38 92 82 35 247
## 138 623.1755 88 46 150 70 354
## 139 529.5126 100 87 48 59 294
## 140 1095.7760 176 242 92 79 589
## 141 659.7043 52 64 110 61 287
## 142 616.9568 104 78 38 46 266
## 143 603.8497 103 108 112 25 348
## 144 490.9129 66 55 51 61 233
## 145 773.0608 86 140 37 74 337
## 146 1125.2130 151 203 73 89 516
## 147 615.8658 80 76 29 135 320
## 148 653.9464 32 163 33 97 325
## 149 667.8192 102 85 121 67 375
## 150 695.0750 94 40 156 82 372
## 151 693.1301 85 156 45 120 406
## 152 651.3301 93 58 51 103 305
## 153 699.4129 43 92 89 96 320
## 154 849.8062 144 116 99 82 441
## 155 589.1862 97 112 102 28 339
## 156 487.7457 72 67 53 73 265
## 157 773.1972 85 110 35 100 330
## 158 1291.2107 176 167 78 193 614
## 159 1173.2334 221 171 79 287 758
## 160 560.8093 78 61 183 36 358
## 161 776.1670 46 109 174 86 415
## 162 843.7062 106 55 88 131 380
## 163 514.0021 95 68 79 40 282
## 164 883.8998 102 178 127 93 500
## 165 639.9533 72 174 89 75 410
## 166 720.9800 129 78 77 85 369
## 167 483.9529 137 121 64 91 413
## 168 535.6651 47 119 160 70 396
## 169 557.1397 114 121 44 20 299
## 170 629.8377 132 127 61 75 395
## 171 650.8408 134 30 140 117 421
## 172 624.5634 59 98 50 113 320
## 173 568.1089 39 141 62 79 321
## 174 817.5954 118 54 93 128 393
## 175 501.8770 108 81 132 106 427
## 176 1105.3291 188 260 105 89 642
## 177 623.0580 67 78 130 73 348
## 178 591.8241 83 43 67 66 259
## 179 506.2047 87 108 37 42 274
## 180 527.3615 59 105 55 64 283
## 181 789.8543 104 127 58 85 374
## 182 629.5878 166 80 47 28 321
## 183 664.6559 160 85 97 26 368
## 184 1239.8764 114 133 313 103 663
## 185 592.8313 49 96 75 60 280
## 186 620.9438 92 42 60 52 246
## 187 561.9286 65 63 105 53 286
## 188 841.6037 102 132 79 81 394
## 189 737.4282 71 84 138 91 384
## 190 657.7836 117 40 82 97 336
## 191 1004.4978 276 76 144 111 607
## 192 648.3628 93 115 110 75 393
## 193 771.5877 46 210 85 55 396
## 194 946.2907 251 49 67 16 383
## 195 545.6132 83 86 135 29 333
## 196 1474.7942 250 93 359 95 797
## 197 765.8219 36 193 44 70 343
## 198 813.3400 93 49 146 73 361
## 199 641.3252 71 60 44 148 323
## 200 806.1221 86 119 103 63 371
## 201 610.9345 64 155 19 135 373
## 202 739.9595 115 65 134 138 452
## 203 1050.6750 325 51 138 69 583
## 204 1127.9447 127 276 149 106 658
## 205 682.0890 77 66 115 82 340
## 206 624.1007 154 85 97 46 382
## 207 613.7779 94 109 99 40 342
## 208 636.4813 75 70 102 84 331
## 209 995.3498 127 172 128 157 584
## 210 954.0968 223 53 86 43 405
## 211 581.5316 109 95 47 56 307
## 212 968.1893 55 254 156 170 635
## 213 577.1904 116 148 71 33 368
## 214 567.2207 138 82 44 34 298
## 215 570.5012 90 115 178 55 438
## 216 1118.7706 185 389 130 95 799
## total_speed num_stops_1 num_stops_2 num_stops_3 num_stops_4
## 1 2.2236257 10 3 2 4
## 2 2.2223098 5 6 1 6
## 3 1.6610102 4 14 5 27
## 4 2.2131669 7 20 4 4
## 5 1.8363273 2 6 6 2
## 6 2.2157926 5 9 3 10
## 7 1.4629588 24 14 6 14
## 8 1.5420680 5 6 7 8
## 9 2.3309855 2 4 2 2
## 10 2.3494530 5 4 5 1
## 11 1.8533750 5 9 3 6
## 12 2.2468670 8 7 13 5
## 13 1.9744093 6 2 3 4
## 14 2.4813839 6 1 2 7
## 15 1.6337793 10 12 11 6
## 16 1.7361311 8 30 26 17
## 17 1.6944531 4 5 3 8
## 18 1.8001438 6 4 6 19
## 19 1.4625569 6 10 5 15
## 20 1.1241761 11 35 30 13
## 21 1.8649091 4 1 16 7
## 22 1.7045220 8 7 7 3
## 23 1.5673217 3 6 25 13
## 24 2.0986618 9 5 4 17
## 25 2.0910175 3 3 5 5
## 26 2.2049593 8 5 2 4
## 27 1.6313984 17 7 11 3
## 28 1.9787785 7 4 1 2
## 29 2.2699808 4 7 4 5
## 30 2.4031349 4 4 2 4
## 31 1.5510424 11 15 14 5
## 32 1.9404944 3 5 4 10
## 33 1.8649739 2 5 4 8
## 34 2.4258973 5 5 4 3
## 35 2.2403245 4 2 5 3
## 36 2.0917033 6 7 9 5
## 37 1.9440386 5 2 4 6
## 38 2.5964340 2 6 10 3
## 39 2.0333248 5 2 7 11
## 40 1.9888222 9 3 2 3
## 41 1.6944841 5 12 5 2
## 42 2.0505204 4 2 5 3
## 43 1.4985295 10 9 13 11
## 44 1.7222024 7 10 7 2
## 45 2.3910302 1 4 2 2
## 46 2.2872208 4 6 5 5
## 47 1.9465925 10 4 6 5
## 48 1.9603193 11 11 5 9
## 49 1.9972149 3 6 3 3
## 50 2.0977569 2 2 9 2
## 51 1.6931479 5 7 7 9
## 52 1.6666503 4 9 7 2
## 53 1.9697781 5 2 4 4
## 54 2.2681176 4 3 4 2
## 55 1.9460731 8 13 3 4
## 56 2.2372255 9 9 6 5
## 57 1.9178219 2 6 5 8
## 58 2.0597021 3 6 8 7
## 59 1.7379345 5 20 10 17
## 60 2.0874109 13 7 40 9
## 61 2.1565383 3 6 6 4
## 62 2.5233087 3 2 2 4
## 63 1.8580906 5 5 7 3
## 64 2.1761669 2 5 5 2
## 65 2.3422966 3 4 3 4
## 66 2.4626232 1 1 5 2
## 67 1.9849006 10 4 3 5
## 68 1.8156832 4 4 13 4
## 69 1.7115291 2 3 4 11
## 70 2.0742511 5 9 5 2
## 71 1.5235058 6 9 3 7
## 72 2.0752818 12 4 6 3
## 73 1.8185253 7 4 3 5
## 74 1.4139419 6 3 8 4
## 75 1.1875478 15 10 15 12
## 76 1.7922335 9 6 11 9
## 77 1.6099599 3 5 10 7
## 78 1.9887271 3 3 5 5
## 79 1.5987679 19 9 8 NA
## 80 1.7209008 12 3 8 4
## 81 1.6670241 4 8 8 5
## 82 2.2025191 3 6 5 14
## 83 1.9922786 4 8 5 9
## 84 1.5872283 8 7 3 9
## 85 1.8727530 2 4 10 3
## 86 1.9009674 6 3 5 2
## 87 1.5314437 5 3 4 4
## 88 1.7858187 2 6 11 4
## 89 1.4115830 6 5 2 5
## 90 1.9022905 6 5 2 7
## 91 1.3380705 15 17 14 6
## 92 1.4754162 12 15 7 4
## 93 2.2786340 2 2 2 3
## 94 2.4377063 1 1 4 1
## 95 1.8195914 6 9 21 4
## 96 1.4457572 5 3 5 20
## 97 1.7693146 2 3 2 5
## 98 1.9714560 5 4 4 3
## 99 1.5827139 5 6 3 7
## 100 1.9354638 12 10 5 8
## 101 1.7509882 3 7 12 4
## 102 2.1156648 4 8 4 4
## 103 0.9493775 5 5 28 3
## 104 1.5820149 9 14 8 1
## 105 2.0800041 2 3 4 7
## 106 1.8149799 13 9 4 3
## 107 1.4168691 9 15 14 11
## 108 1.4113203 10 9 19 13
## 109 2.0515128 6 7 3 3
## 110 1.9972604 7 2 3 5
## 111 1.6584082 13 10 6 13
## 112 1.8899826 12 8 10 3
## 113 2.0659953 3 2 15 4
## 114 1.9335882 5 8 6 4
## 115 1.6793085 9 6 4 7
## 116 1.4592729 12 13 5 5
## 117 1.7761339 10 2 8 10
## 118 1.5077439 4 5 4 3
## 119 1.4461962 9 10 12 6
## 120 1.8521998 8 9 6 6
## 121 2.2152317 5 2 3 4
## 122 2.1076907 3 2 1 5
## 123 1.9730258 2 6 6 3
## 124 2.0927735 4 7 7 5
## 125 2.0271832 3 6 2 4
## 126 2.0463984 5 1 6 2
## 127 1.3319106 10 18 5 8
## 128 1.7254594 4 2 5 4
## 129 1.3895982 7 8 2 3
## 130 1.9414845 5 8 3 3
## 131 1.7671420 6 9 6 8
## 132 1.3094501 7 7 6 10
## 133 2.2541882 3 6 6 5
## 134 2.4798461 6 4 4 5
## 135 2.2207614 7 8 15 6
## 136 2.3784972 6 4 5 4
## 137 2.1293309 2 7 4 2
## 138 1.7603828 5 2 5 3
## 139 1.8010632 10 4 3 6
## 140 1.8604008 4 11 4 2
## 141 2.2986211 3 2 6 4
## 142 2.3193865 4 4 2 3
## 143 1.7352002 13 10 8 3
## 144 2.1069223 5 6 2 7
## 145 2.2939491 2 1 5 2
## 146 2.1806454 1 13 2 4
## 147 1.9245805 8 7 2 4
## 148 2.0121427 3 3 5 7
## 149 1.7808512 4 3 3 3
## 150 1.8684812 4 2 8 4
## 151 1.7072169 5 10 4 15
## 152 2.1355086 4 1 5 3
## 153 2.1856652 4 2 4 3
## 154 1.9269981 2 10 3 1
## 155 1.7380124 8 3 3 2
## 156 1.8405498 9 2 5 2
## 157 2.3430220 5 1 3 6
## 158 2.1029491 6 2 6 9
## 159 1.5478013 14 11 9 30
## 160 1.5665063 8 8 12 2
## 161 1.8702818 2 3 7 2
## 162 2.2202795 3 7 2 3
## 163 1.8227024 4 3 2 7
## 164 1.7677996 11 9 9 8
## 165 1.5608616 3 9 15 8
## 166 1.9538752 5 7 7 4
## 167 1.1717989 12 9 7 11
## 168 1.3526895 9 16 27 5
## 169 1.8633435 6 1 4 5
## 170 1.5945257 5 10 7 11
## 171 1.5459401 11 2 7 8
## 172 1.9517606 8 10 3 6
## 173 1.7698097 7 12 3 3
## 174 2.0803954 4 5 2 3
## 175 1.1753561 9 4 21 10
## 176 1.7216964 10 18 4 7
## 177 1.7903966 3 3 6 6
## 178 2.2850351 2 2 2 3
## 179 1.8474626 3 6 2 3
## 180 1.8634683 3 3 3 2
## 181 2.1119098 6 3 4 5
## 182 1.9613328 9 5 3 4
## 183 1.8061301 14 6 4 2
## 184 1.8701001 13 4 20 7
## 185 2.1172547 2 3 4 3
## 186 2.5241619 4 3 1 3
## 187 1.9647852 2 4 5 2
## 188 2.1360500 6 6 4 2
## 189 1.9203859 2 4 8 9
## 190 1.9576892 4 4 3 5
## 191 1.6548564 27 4 19 3
## 192 1.6497780 14 9 20 3
## 193 1.9484538 3 12 6 4
## 194 2.4707330 3 1 4 2
## 195 1.6384780 15 8 6 2
## 196 1.8504319 14 8 20 8
## 197 2.2327170 2 5 4 2
## 198 2.2530193 4 4 3 2
## 199 1.9855268 5 5 4 7
## 200 2.1728359 6 3 4 5
## 201 1.6378940 4 4 2 6
## 202 1.6370785 4 1 4 8
## 203 1.8021870 27 7 10 4
## 204 1.7142017 12 17 21 6
## 205 2.0061441 5 2 4 11
## 206 1.6337714 25 8 7 7
## 207 1.7946723 17 9 7 4
## 208 1.9229043 7 8 4 5
## 209 1.7043661 5 9 10 11
## 210 2.3557945 6 3 4 6
## 211 1.8942397 8 6 5 5
## 212 1.5247075 6 28 9 15
## 213 1.5684523 3 2 6 4
## 214 1.9034253 2 6 2 2
## 215 1.3025141 9 9 16 10
## 216 1.4002135 21 40 12 6
## total_walkingstops stops_duration_1 stops_duration_2 stops_duration_3
## 1 19 14.488 6.035 0.952
## 2 18 0.004 0.099 0.001
## 3 50 8.371 48.353 12.056
## 4 35 0.765 7.657 0.010
## 5 16 23.859 24.717 32.248
## 6 27 19.988 0.205 0.003
## 7 58 24.727 51.006 22.478
## 8 26 0.205 44.273 6.688
## 9 10 12.196 13.964 9.218
## 10 15 0.007 0.128 0.434
## 11 23 15.414 10.149 11.663
## 12 33 0.548 8.040 5.189
## 13 15 21.824 4.068 10.480
## 14 16 11.288 0.001 0.001
## 15 39 5.104 27.981 3.244
## 16 81 6.891 14.525 40.881
## 17 20 1.321 13.769 0.003
## 18 35 19.073 1.625 48.822
## 19 36 13.235 30.231 16.842
## 20 89 34.899 54.113 61.627
## 21 28 14.158 21.780 29.917
## 22 25 15.432 22.906 20.636
## 23 47 5.360 18.377 98.422
## 24 35 0.520 8.927 0.012
## 25 16 12.828 15.729 29.721
## 26 19 27.773 13.474 12.810
## 27 38 34.720 30.423 20.372
## 28 14 1.138 0.008 0.003
## 29 20 0.065 2.104 5.725
## 30 14 10.994 15.649 0.001
## 31 45 19.691 22.864 46.597
## 32 22 12.385 12.289 14.255
## 33 19 31.472 36.534 13.194
## 34 17 0.004 0.908 3.046
## 35 14 5.907 13.662 5.849
## 36 27 9.187 10.234 1.028
## 37 17 17.372 34.278 13.700
## 38 21 8.346 0.778 2.608
## 39 25 0.009 0.004 0.228
## 40 17 6.605 8.964 14.087
## 41 24 0.004 3.596 1.203
## 42 14 19.350 16.861 1.239
## 43 43 44.032 21.443 40.863
## 44 26 24.826 13.526 20.154
## 45 9 18.259 6.134 0.002
## 46 20 0.610 10.269 13.678
## 47 25 22.179 27.587 19.004
## 48 36 9.535 11.739 0.637
## 49 15 21.557 16.040 13.605
## 50 15 21.367 23.614 23.422
## 51 28 0.008 0.014 0.517
## 52 22 25.128 20.890 35.990
## 53 15 2.775 28.661 0.035
## 54 13 22.276 8.934 6.389
## 55 28 17.764 8.334 16.237
## 56 29 11.589 12.271 0.213
## 57 21 13.048 6.622 25.554
## 58 24 0.511 0.005 0.158
## 59 52 16.580 44.080 5.642
## 60 69 13.213 0.013 501.631
## 61 19 6.879 15.548 37.880
## 62 11 13.421 5.945 7.619
## 63 20 0.008 0.011 4.684
## 64 14 3.621 10.446 7.358
## 65 14 6.851 6.761 7.416
## 66 9 8.852 0.001 2.414
## 67 22 33.194 5.496 5.915
## 68 25 0.008 0.006 1.283
## 69 20 26.226 61.767 17.205
## 70 21 0.036 3.785 12.120
## 71 25 16.469 35.935 18.052
## 72 25 19.395 6.465 23.652
## 73 19 30.880 18.476 20.834
## 74 21 33.452 29.957 50.656
## 75 52 0.696 0.586 13.200
## 76 35 9.610 30.879 3.471
## 77 25 35.208 11.583 48.029
## 78 16 22.606 19.059 11.129
## 79 36 40.435 36.976 4.414
## 80 27 0.100 0.252 9.003
## 81 25 0.844 21.528 4.791
## 82 28 17.325 2.562 4.976
## 83 26 11.484 6.490 20.426
## 84 27 5.183 10.598 53.375
## 85 19 28.079 34.200 7.068
## 86 16 36.034 36.997 25.882
## 87 16 36.449 21.366 20.118
## 88 23 0.004 0.021 0.051
## 89 18 38.861 72.603 19.370
## 90 20 46.881 0.524 20.258
## 91 52 100.775 57.076 15.555
## 92 38 0.020 40.063 20.251
## 93 9 0.116 7.156 4.661
## 94 7 15.453 3.740 1.021
## 95 40 9.165 3.161 24.044
## 96 33 12.646 7.741 34.809
## 97 12 24.826 48.099 17.677
## 98 16 0.005 0.134 0.003
## 99 21 26.982 18.984 21.103
## 100 35 11.283 28.545 0.156
## 101 26 21.500 32.670 89.693
## 102 20 28.202 20.964 17.195
## 103 41 0.012 0.011 318.407
## 104 32 28.980 28.450 21.236
## 105 16 0.348 12.225 1.176
## 106 29 27.139 24.212 18.955
## 107 49 65.529 20.653 14.791
## 108 51 18.700 13.071 59.157
## 109 19 6.873 24.331 16.834
## 110 17 0.038 0.066 2.024
## 111 42 29.652 35.380 10.978
## 112 33 20.299 26.739 8.606
## 113 24 7.972 2.113 56.052
## 114 23 12.371 15.512 27.625
## 115 26 0.019 0.010 0.008
## 116 35 28.726 24.464 11.064
## 117 30 1.519 27.300 0.067
## 118 16 25.505 47.552 23.340
## 119 37 29.542 34.770 35.749
## 120 29 34.362 31.467 1.462
## 121 14 8.456 15.028 17.295
## 122 11 0.032 0.097 0.001
## 123 17 9.449 15.286 6.380
## 124 23 5.393 7.592 8.298
## 125 15 10.187 1.521 0.002
## 126 14 25.831 16.937 0.005
## 127 41 0.014 8.014 1.430
## 128 15 15.829 0.002 0.008
## 129 20 39.641 29.354 16.227
## 130 19 20.467 0.214 5.472
## 131 29 25.657 29.559 15.414
## 132 30 0.018 0.064 4.940
## 133 20 15.959 9.100 11.608
## 134 19 8.677 2.452 1.954
## 135 36 2.789 10.565 12.038
## 136 19 1.987 0.008 5.775
## 137 15 8.516 16.678 12.524
## 138 15 17.054 18.361 44.253
## 139 23 0.019 0.008 1.584
## 140 21 6.691 9.548 0.162
## 141 15 11.293 13.388 3.974
## 142 13 8.069 7.391 10.831
## 143 34 34.240 23.517 19.710
## 144 20 0.010 0.878 7.631
## 145 10 1.534 31.435 1.557
## 146 20 31.356 4.041 14.837
## 147 21 12.676 29.850 4.332
## 148 18 7.807 11.395 11.868
## 149 13 38.621 27.258 24.120
## 150 18 19.857 8.921 49.794
## 151 34 25.375 30.623 10.740
## 152 13 1.105 5.177 0.014
## 153 13 12.554 12.061 14.839
## 154 16 33.299 1.220 17.486
## 155 16 22.199 25.324 11.957
## 156 18 5.281 0.003 2.613
## 157 15 0.089 15.712 0.032
## 158 23 25.500 32.406 0.005
## 159 64 14.647 26.125 30.596
## 160 30 17.184 19.986 19.637
## 161 14 21.856 30.306 31.694
## 162 15 0.002 0.101 0.002
## 163 16 19.490 18.930 15.345
## 164 37 18.863 30.145 0.986
## 165 35 33.009 24.171 31.876
## 166 23 29.716 1.497 10.122
## 167 39 2.158 0.537 6.243
## 168 57 13.702 17.381 40.996
## 169 16 0.307 19.340 0.292
## 170 33 36.694 43.661 15.326
## 171 28 19.068 5.589 30.012
## 172 27 22.169 21.946 2.894
## 173 25 7.965 25.553 15.582
## 174 14 0.004 0.099 0.001
## 175 44 39.178 28.393 58.608
## 176 39 33.130 14.675 0.055
## 177 18 22.011 19.718 27.017
## 178 9 16.556 10.442 7.990
## 179 14 0.008 0.012 0.148
## 180 11 17.753 6.777 4.347
## 181 18 0.119 16.309 1.227
## 182 21 35.961 11.020 12.911
## 183 26 20.065 17.132 5.861
## 184 44 6.544 2.108 33.289
## 185 12 16.481 3.627 15.728
## 186 11 0.006 0.003 0.001
## 187 13 6.873 0.542 16.475
## 188 18 9.514 1.062 1.057
## 189 23 16.608 2.055 33.631
## 190 16 11.163 2.639 17.248
## 191 53 1.682 0.011 13.979
## 192 46 11.404 5.346 14.569
## 193 25 18.950 58.792 13.820
## 194 10 25.287 3.697 3.054
## 195 31 11.809 21.191 49.283
## 196 50 0.589 0.396 14.468
## 197 13 13.700 30.361 8.920
## 198 13 0.004 0.003 0.003
## 199 21 12.116 16.309 17.758
## 200 18 6.325 8.913 10.308
## 201 16 16.349 37.765 5.808
## 202 17 20.096 0.001 0.507
## 203 48 0.409 1.338 50.961
## 204 56 21.366 24.869 106.784
## 205 22 18.844 11.953 19.608
## 206 47 35.096 21.702 44.792
## 207 37 18.273 5.629 15.521
## 208 24 1.757 12.604 0.010
## 209 35 42.657 2.166 2.878
## 210 19 23.265 9.593 1.533
## 211 24 0.016 0.011 4.353
## 212 58 15.424 66.733 4.640
## 213 15 0.002 51.745 1.002
## 214 12 28.664 9.359 15.317
## 215 44 24.788 32.601 58.621
## 216 79 9.547 92.073 12.294
## stops_duration_4 total_walkingstop_duration
## 1 1.545 23.020
## 2 13.486 13.590
## 3 16.506 85.286
## 4 0.004 8.436
## 5 17.601 98.425
## 6 17.765 37.961
## 7 32.521 130.732
## 8 0.020 51.186
## 9 4.968 40.346
## 10 8.028 8.597
## 11 18.175 55.401
## 12 0.056 13.833
## 13 0.001 36.373
## 14 0.533 11.823
## 15 0.009 36.338
## 16 27.567 89.864
## 17 0.802 15.895
## 18 32.572 102.092
## 19 17.799 78.107
## 20 32.310 182.949
## 21 27.744 93.599
## 22 28.023 86.997
## 23 20.869 143.028
## 24 7.545 17.004
## 25 17.662 75.940
## 26 33.242 87.299
## 27 5.609 91.124
## 28 0.563 1.712
## 29 28.045 35.939
## 30 2.677 29.321
## 31 14.202 103.354
## 32 23.576 62.505
## 33 18.295 99.495
## 34 4.574 8.532
## 35 7.615 33.033
## 36 12.694 33.143
## 37 16.381 81.731
## 38 6.269 18.001
## 39 2.185 2.426
## 40 3.295 32.951
## 41 38.009 42.812
## 42 23.322 60.772
## 43 15.582 121.920
## 44 17.423 75.929
## 45 4.792 29.187
## 46 1.539 26.096
## 47 8.905 77.675
## 48 5.817 27.728
## 49 31.464 82.666
## 50 5.083 73.486
## 51 10.804 11.343
## 52 14.406 96.414
## 53 0.165 31.636
## 54 9.808 47.407
## 55 8.583 50.918
## 56 4.653 28.726
## 57 15.463 60.687
## 58 1.027 1.701
## 59 12.810 79.112
## 60 17.901 532.758
## 61 0.672 60.979
## 62 3.434 30.419
## 63 2.075 6.778
## 64 3.013 24.438
## 65 14.615 35.643
## 66 12.234 23.501
## 67 5.310 49.915
## 68 0.009 1.306
## 69 38.241 143.439
## 70 0.002 15.943
## 71 15.319 85.775
## 72 5.900 55.412
## 73 23.470 93.660
## 74 48.121 162.186
## 75 2.336 16.818
## 76 8.170 52.130
## 77 39.321 134.141
## 78 1.558 54.352
## 79 NA 81.825
## 80 0.219 9.574
## 81 0.824 27.987
## 82 35.894 60.757
## 83 13.828 52.228
## 84 28.364 97.520
## 85 42.356 111.703
## 86 32.065 130.978
## 87 28.768 106.701
## 88 6.844 6.920
## 89 70.661 201.495
## 90 20.770 88.433
## 91 9.531 182.937
## 92 8.751 69.085
## 93 0.063 11.996
## 94 0.001 20.215
## 95 25.306 61.676
## 96 77.867 133.063
## 97 30.804 121.406
## 98 0.002 0.144
## 99 16.538 83.607
## 100 0.531 40.515
## 101 50.954 194.817
## 102 24.829 91.190
## 103 11.720 330.150
## 104 9.475 88.141
## 105 9.396 23.145
## 106 27.543 97.849
## 107 17.295 118.268
## 108 18.940 109.868
## 109 13.577 61.615
## 110 31.979 34.107
## 111 23.181 99.191
## 112 3.809 59.453
## 113 4.947 71.084
## 114 21.924 77.432
## 115 2.442 2.479
## 116 8.764 73.018
## 117 0.228 29.114
## 118 42.711 139.108
## 119 28.377 128.438
## 120 18.864 86.155
## 121 0.434 41.213
## 122 1.018 1.148
## 123 13.831 44.946
## 124 3.088 24.371
## 125 21.032 32.742
## 126 2.049 44.822
## 127 22.036 31.494
## 128 0.009 15.848
## 129 35.598 120.820
## 130 21.561 47.714
## 131 13.211 83.841
## 132 7.711 12.733
## 133 9.162 45.829
## 134 2.885 15.968
## 135 4.754 30.146
## 136 0.176 7.946
## 137 4.148 41.866
## 138 7.515 87.183
## 139 6.031 7.642
## 140 0.001 16.402
## 141 9.146 37.801
## 142 8.188 34.479
## 143 6.037 83.504
## 144 1.305 9.824
## 145 20.370 54.896
## 146 15.306 65.540
## 147 22.039 68.897
## 148 15.145 46.215
## 149 0.130 90.129
## 150 13.579 92.151
## 151 24.169 90.907
## 152 3.563 9.859
## 153 9.652 49.106
## 154 20.263 72.268
## 155 0.354 59.834
## 156 1.080 8.977
## 157 1.708 17.541
## 158 5.832 63.743
## 159 65.559 136.927
## 160 23.036 79.843
## 161 33.668 117.524
## 162 0.001 0.106
## 163 3.713 57.478
## 164 17.228 67.222
## 165 16.682 105.738
## 166 15.126 56.461
## 167 6.785 15.723
## 168 12.614 84.693
## 169 7.077 27.016
## 170 33.320 129.001
## 171 4.207 58.876
## 172 4.999 52.008
## 173 21.098 70.198
## 174 0.028 0.132
## 175 36.143 162.322
## 176 2.205 50.065
## 177 12.344 81.090
## 178 8.935 43.923
## 179 10.502 10.670
## 180 11.284 40.161
## 181 4.106 21.761
## 182 7.432 67.324
## 183 3.942 47.000
## 184 10.797 52.738
## 185 9.203 45.039
## 186 0.001 0.011
## 187 0.003 23.893
## 188 10.206 21.839
## 189 12.325 64.619
## 190 12.301 43.351
## 191 15.995 31.667
## 192 12.868 44.187
## 193 6.794 98.356
## 194 6.198 38.236
## 195 6.504 88.787
## 196 25.167 40.620
## 197 15.104 68.085
## 198 6.748 6.758
## 199 18.060 64.243
## 200 6.456 32.002
## 201 28.023 87.945
## 202 1.302 21.906
## 203 0.008 52.716
## 204 0.537 153.556
## 205 6.577 56.982
## 206 14.916 116.506
## 207 12.719 52.142
## 208 1.107 15.478
## 209 66.589 114.290
## 210 2.499 36.890
## 211 8.620 13.000
## 212 26.087 112.884
## 213 12.524 65.273
## 214 18.435 71.775
## 215 18.740 134.750
## 216 0.015 113.929# Load the here package
library(here)## here() starts at /Users/monabartling/Documents/Arbeit/Projekte/FWF Schrödinger/Publications/CAVE study/cave_context_aware_mobile_maps/trajectory_analysis# Write the resulting data frame to a CSV file in the project root directory
write.csv(result_df, file = here("trajectory_analysis.csv"), row.names = FALSE)# Define the folder path
folder_path <- "workfiles"
# Delete the folder
unlink(folder_path, recursive = TRUE)